package com.zl.project.pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;
/**
 * 用于添加SQL语句的条件
 * 进行去重排序与分类
 * @author 12642
 *
 */
public class promesgExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public promesgExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andPromesgidIsNull() {
            addCriterion("promesgid is null");
            return (Criteria) this;
        }

        public Criteria andPromesgidIsNotNull() {
            addCriterion("promesgid is not null");
            return (Criteria) this;
        }

        public Criteria andPromesgidEqualTo(Integer value) {
            addCriterion("promesgid =", value, "promesgid");
            return (Criteria) this;
        }

        public Criteria andPromesgidNotEqualTo(Integer value) {
            addCriterion("promesgid <>", value, "promesgid");
            return (Criteria) this;
        }

        public Criteria andPromesgidGreaterThan(Integer value) {
            addCriterion("promesgid >", value, "promesgid");
            return (Criteria) this;
        }

        public Criteria andPromesgidGreaterThanOrEqualTo(Integer value) {
            addCriterion("promesgid >=", value, "promesgid");
            return (Criteria) this;
        }

        public Criteria andPromesgidLessThan(Integer value) {
            addCriterion("promesgid <", value, "promesgid");
            return (Criteria) this;
        }

        public Criteria andPromesgidLessThanOrEqualTo(Integer value) {
            addCriterion("promesgid <=", value, "promesgid");
            return (Criteria) this;
        }

        public Criteria andPromesgidIn(List<Integer> values) {
            addCriterion("promesgid in", values, "promesgid");
            return (Criteria) this;
        }

        public Criteria andPromesgidNotIn(List<Integer> values) {
            addCriterion("promesgid not in", values, "promesgid");
            return (Criteria) this;
        }

        public Criteria andPromesgidBetween(Integer value1, Integer value2) {
            addCriterion("promesgid between", value1, value2, "promesgid");
            return (Criteria) this;
        }

        public Criteria andPromesgidNotBetween(Integer value1, Integer value2) {
            addCriterion("promesgid not between", value1, value2, "promesgid");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("userid is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("userid is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(Integer value) {
            addCriterion("userid =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(Integer value) {
            addCriterion("userid <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(Integer value) {
            addCriterion("userid >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(Integer value) {
            addCriterion("userid >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(Integer value) {
            addCriterion("userid <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(Integer value) {
            addCriterion("userid <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<Integer> values) {
            addCriterion("userid in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<Integer> values) {
            addCriterion("userid not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(Integer value1, Integer value2) {
            addCriterion("userid between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(Integer value1, Integer value2) {
            addCriterion("userid not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andProtimeIsNull() {
            addCriterion("protime is null");
            return (Criteria) this;
        }

        public Criteria andProtimeIsNotNull() {
            addCriterion("protime is not null");
            return (Criteria) this;
        }

        public Criteria andProtimeEqualTo(Date value) {
            addCriterion("protime =", value, "protime");
            return (Criteria) this;
        }

        public Criteria andProtimeNotEqualTo(Date value) {
            addCriterion("protime <>", value, "protime");
            return (Criteria) this;
        }

        public Criteria andProtimeGreaterThan(Date value) {
            addCriterion("protime >", value, "protime");
            return (Criteria) this;
        }

        public Criteria andProtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("protime >=", value, "protime");
            return (Criteria) this;
        }

        public Criteria andProtimeLessThan(Date value) {
            addCriterion("protime <", value, "protime");
            return (Criteria) this;
        }

        public Criteria andProtimeLessThanOrEqualTo(Date value) {
            addCriterion("protime <=", value, "protime");
            return (Criteria) this;
        }

        public Criteria andProtimeIn(List<Date> values) {
            addCriterion("protime in", values, "protime");
            return (Criteria) this;
        }

        public Criteria andProtimeNotIn(List<Date> values) {
            addCriterion("protime not in", values, "protime");
            return (Criteria) this;
        }

        public Criteria andProtimeBetween(Date value1, Date value2) {
            addCriterion("protime between", value1, value2, "protime");
            return (Criteria) this;
        }

        public Criteria andProtimeNotBetween(Date value1, Date value2) {
            addCriterion("protime not between", value1, value2, "protime");
            return (Criteria) this;
        }

        public Criteria andProtitleIsNull() {
            addCriterion("protitle is null");
            return (Criteria) this;
        }

        public Criteria andProtitleIsNotNull() {
            addCriterion("protitle is not null");
            return (Criteria) this;
        }

        public Criteria andProtitleEqualTo(String value) {
            addCriterion("protitle =", value, "protitle");
            return (Criteria) this;
        }

        public Criteria andProtitleNotEqualTo(String value) {
            addCriterion("protitle <>", value, "protitle");
            return (Criteria) this;
        }

        public Criteria andProtitleGreaterThan(String value) {
            addCriterion("protitle >", value, "protitle");
            return (Criteria) this;
        }

        public Criteria andProtitleGreaterThanOrEqualTo(String value) {
            addCriterion("protitle >=", value, "protitle");
            return (Criteria) this;
        }

        public Criteria andProtitleLessThan(String value) {
            addCriterion("protitle <", value, "protitle");
            return (Criteria) this;
        }

        public Criteria andProtitleLessThanOrEqualTo(String value) {
            addCriterion("protitle <=", value, "protitle");
            return (Criteria) this;
        }

        public Criteria andProtitleLike(String value) {
            addCriterion("protitle like", value, "protitle");
            return (Criteria) this;
        }

        public Criteria andProtitleNotLike(String value) {
            addCriterion("protitle not like", value, "protitle");
            return (Criteria) this;
        }

        public Criteria andProtitleIn(List<String> values) {
            addCriterion("protitle in", values, "protitle");
            return (Criteria) this;
        }

        public Criteria andProtitleNotIn(List<String> values) {
            addCriterion("protitle not in", values, "protitle");
            return (Criteria) this;
        }

        public Criteria andProtitleBetween(String value1, String value2) {
            addCriterion("protitle between", value1, value2, "protitle");
            return (Criteria) this;
        }

        public Criteria andProtitleNotBetween(String value1, String value2) {
            addCriterion("protitle not between", value1, value2, "protitle");
            return (Criteria) this;
        }

        public Criteria andProitemsIsNull() {
            addCriterion("proitems is null");
            return (Criteria) this;
        }

        public Criteria andProitemsIsNotNull() {
            addCriterion("proitems is not null");
            return (Criteria) this;
        }

        public Criteria andProitemsEqualTo(String value) {
            addCriterion("proitems =", value, "proitems");
            return (Criteria) this;
        }

        public Criteria andProitemsNotEqualTo(String value) {
            addCriterion("proitems <>", value, "proitems");
            return (Criteria) this;
        }

        public Criteria andProitemsGreaterThan(String value) {
            addCriterion("proitems >", value, "proitems");
            return (Criteria) this;
        }

        public Criteria andProitemsGreaterThanOrEqualTo(String value) {
            addCriterion("proitems >=", value, "proitems");
            return (Criteria) this;
        }

        public Criteria andProitemsLessThan(String value) {
            addCriterion("proitems <", value, "proitems");
            return (Criteria) this;
        }

        public Criteria andProitemsLessThanOrEqualTo(String value) {
            addCriterion("proitems <=", value, "proitems");
            return (Criteria) this;
        }

        public Criteria andProitemsLike(String value) {
            addCriterion("proitems like", value, "proitems");
            return (Criteria) this;
        }

        public Criteria andProitemsNotLike(String value) {
            addCriterion("proitems not like", value, "proitems");
            return (Criteria) this;
        }

        public Criteria andProitemsIn(List<String> values) {
            addCriterion("proitems in", values, "proitems");
            return (Criteria) this;
        }

        public Criteria andProitemsNotIn(List<String> values) {
            addCriterion("proitems not in", values, "proitems");
            return (Criteria) this;
        }

        public Criteria andProitemsBetween(String value1, String value2) {
            addCriterion("proitems between", value1, value2, "proitems");
            return (Criteria) this;
        }

        public Criteria andProitemsNotBetween(String value1, String value2) {
            addCriterion("proitems not between", value1, value2, "proitems");
            return (Criteria) this;
        }

        public Criteria andOriginreqIsNull() {
            addCriterion("originreq is null");
            return (Criteria) this;
        }

        public Criteria andOriginreqIsNotNull() {
            addCriterion("originreq is not null");
            return (Criteria) this;
        }

        public Criteria andOriginreqEqualTo(String value) {
            addCriterion("originreq =", value, "originreq");
            return (Criteria) this;
        }

        public Criteria andOriginreqNotEqualTo(String value) {
            addCriterion("originreq <>", value, "originreq");
            return (Criteria) this;
        }

        public Criteria andOriginreqGreaterThan(String value) {
            addCriterion("originreq >", value, "originreq");
            return (Criteria) this;
        }

        public Criteria andOriginreqGreaterThanOrEqualTo(String value) {
            addCriterion("originreq >=", value, "originreq");
            return (Criteria) this;
        }

        public Criteria andOriginreqLessThan(String value) {
            addCriterion("originreq <", value, "originreq");
            return (Criteria) this;
        }

        public Criteria andOriginreqLessThanOrEqualTo(String value) {
            addCriterion("originreq <=", value, "originreq");
            return (Criteria) this;
        }

        public Criteria andOriginreqLike(String value) {
            addCriterion("originreq like", value, "originreq");
            return (Criteria) this;
        }

        public Criteria andOriginreqNotLike(String value) {
            addCriterion("originreq not like", value, "originreq");
            return (Criteria) this;
        }

        public Criteria andOriginreqIn(List<String> values) {
            addCriterion("originreq in", values, "originreq");
            return (Criteria) this;
        }

        public Criteria andOriginreqNotIn(List<String> values) {
            addCriterion("originreq not in", values, "originreq");
            return (Criteria) this;
        }

        public Criteria andOriginreqBetween(String value1, String value2) {
            addCriterion("originreq between", value1, value2, "originreq");
            return (Criteria) this;
        }

        public Criteria andOriginreqNotBetween(String value1, String value2) {
            addCriterion("originreq not between", value1, value2, "originreq");
            return (Criteria) this;
        }

        public Criteria andSpecIsNull() {
            addCriterion("spec is null");
            return (Criteria) this;
        }

        public Criteria andSpecIsNotNull() {
            addCriterion("spec is not null");
            return (Criteria) this;
        }

        public Criteria andSpecEqualTo(String value) {
            addCriterion("spec =", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecNotEqualTo(String value) {
            addCriterion("spec <>", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecGreaterThan(String value) {
            addCriterion("spec >", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecGreaterThanOrEqualTo(String value) {
            addCriterion("spec >=", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecLessThan(String value) {
            addCriterion("spec <", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecLessThanOrEqualTo(String value) {
            addCriterion("spec <=", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecLike(String value) {
            addCriterion("spec like", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecNotLike(String value) {
            addCriterion("spec not like", value, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecIn(List<String> values) {
            addCriterion("spec in", values, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecNotIn(List<String> values) {
            addCriterion("spec not in", values, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecBetween(String value1, String value2) {
            addCriterion("spec between", value1, value2, "spec");
            return (Criteria) this;
        }

        public Criteria andSpecNotBetween(String value1, String value2) {
            addCriterion("spec not between", value1, value2, "spec");
            return (Criteria) this;
        }

        public Criteria andLevelreqIsNull() {
            addCriterion("levelreq is null");
            return (Criteria) this;
        }

        public Criteria andLevelreqIsNotNull() {
            addCriterion("levelreq is not null");
            return (Criteria) this;
        }

        public Criteria andLevelreqEqualTo(String value) {
            addCriterion("levelreq =", value, "levelreq");
            return (Criteria) this;
        }

        public Criteria andLevelreqNotEqualTo(String value) {
            addCriterion("levelreq <>", value, "levelreq");
            return (Criteria) this;
        }

        public Criteria andLevelreqGreaterThan(String value) {
            addCriterion("levelreq >", value, "levelreq");
            return (Criteria) this;
        }

        public Criteria andLevelreqGreaterThanOrEqualTo(String value) {
            addCriterion("levelreq >=", value, "levelreq");
            return (Criteria) this;
        }

        public Criteria andLevelreqLessThan(String value) {
            addCriterion("levelreq <", value, "levelreq");
            return (Criteria) this;
        }

        public Criteria andLevelreqLessThanOrEqualTo(String value) {
            addCriterion("levelreq <=", value, "levelreq");
            return (Criteria) this;
        }

        public Criteria andLevelreqLike(String value) {
            addCriterion("levelreq like", value, "levelreq");
            return (Criteria) this;
        }

        public Criteria andLevelreqNotLike(String value) {
            addCriterion("levelreq not like", value, "levelreq");
            return (Criteria) this;
        }

        public Criteria andLevelreqIn(List<String> values) {
            addCriterion("levelreq in", values, "levelreq");
            return (Criteria) this;
        }

        public Criteria andLevelreqNotIn(List<String> values) {
            addCriterion("levelreq not in", values, "levelreq");
            return (Criteria) this;
        }

        public Criteria andLevelreqBetween(String value1, String value2) {
            addCriterion("levelreq between", value1, value2, "levelreq");
            return (Criteria) this;
        }

        public Criteria andLevelreqNotBetween(String value1, String value2) {
            addCriterion("levelreq not between", value1, value2, "levelreq");
            return (Criteria) this;
        }

        public Criteria andStorereqIsNull() {
            addCriterion("storereq is null");
            return (Criteria) this;
        }

        public Criteria andStorereqIsNotNull() {
            addCriterion("storereq is not null");
            return (Criteria) this;
        }

        public Criteria andStorereqEqualTo(String value) {
            addCriterion("storereq =", value, "storereq");
            return (Criteria) this;
        }

        public Criteria andStorereqNotEqualTo(String value) {
            addCriterion("storereq <>", value, "storereq");
            return (Criteria) this;
        }

        public Criteria andStorereqGreaterThan(String value) {
            addCriterion("storereq >", value, "storereq");
            return (Criteria) this;
        }

        public Criteria andStorereqGreaterThanOrEqualTo(String value) {
            addCriterion("storereq >=", value, "storereq");
            return (Criteria) this;
        }

        public Criteria andStorereqLessThan(String value) {
            addCriterion("storereq <", value, "storereq");
            return (Criteria) this;
        }

        public Criteria andStorereqLessThanOrEqualTo(String value) {
            addCriterion("storereq <=", value, "storereq");
            return (Criteria) this;
        }

        public Criteria andStorereqLike(String value) {
            addCriterion("storereq like", value, "storereq");
            return (Criteria) this;
        }

        public Criteria andStorereqNotLike(String value) {
            addCriterion("storereq not like", value, "storereq");
            return (Criteria) this;
        }

        public Criteria andStorereqIn(List<String> values) {
            addCriterion("storereq in", values, "storereq");
            return (Criteria) this;
        }

        public Criteria andStorereqNotIn(List<String> values) {
            addCriterion("storereq not in", values, "storereq");
            return (Criteria) this;
        }

        public Criteria andStorereqBetween(String value1, String value2) {
            addCriterion("storereq between", value1, value2, "storereq");
            return (Criteria) this;
        }

        public Criteria andStorereqNotBetween(String value1, String value2) {
            addCriterion("storereq not between", value1, value2, "storereq");
            return (Criteria) this;
        }

        public Criteria andFutorspotIsNull() {
            addCriterion("futorspot is null");
            return (Criteria) this;
        }

        public Criteria andFutorspotIsNotNull() {
            addCriterion("futorspot is not null");
            return (Criteria) this;
        }

        public Criteria andFutorspotEqualTo(String value) {
            addCriterion("futorspot =", value, "futorspot");
            return (Criteria) this;
        }

        public Criteria andFutorspotNotEqualTo(String value) {
            addCriterion("futorspot <>", value, "futorspot");
            return (Criteria) this;
        }

        public Criteria andFutorspotGreaterThan(String value) {
            addCriterion("futorspot >", value, "futorspot");
            return (Criteria) this;
        }

        public Criteria andFutorspotGreaterThanOrEqualTo(String value) {
            addCriterion("futorspot >=", value, "futorspot");
            return (Criteria) this;
        }

        public Criteria andFutorspotLessThan(String value) {
            addCriterion("futorspot <", value, "futorspot");
            return (Criteria) this;
        }

        public Criteria andFutorspotLessThanOrEqualTo(String value) {
            addCriterion("futorspot <=", value, "futorspot");
            return (Criteria) this;
        }

        public Criteria andFutorspotLike(String value) {
            addCriterion("futorspot like", value, "futorspot");
            return (Criteria) this;
        }

        public Criteria andFutorspotNotLike(String value) {
            addCriterion("futorspot not like", value, "futorspot");
            return (Criteria) this;
        }

        public Criteria andFutorspotIn(List<String> values) {
            addCriterion("futorspot in", values, "futorspot");
            return (Criteria) this;
        }

        public Criteria andFutorspotNotIn(List<String> values) {
            addCriterion("futorspot not in", values, "futorspot");
            return (Criteria) this;
        }

        public Criteria andFutorspotBetween(String value1, String value2) {
            addCriterion("futorspot between", value1, value2, "futorspot");
            return (Criteria) this;
        }

        public Criteria andFutorspotNotBetween(String value1, String value2) {
            addCriterion("futorspot not between", value1, value2, "futorspot");
            return (Criteria) this;
        }

        public Criteria andPricereqIsNull() {
            addCriterion("pricereq is null");
            return (Criteria) this;
        }

        public Criteria andPricereqIsNotNull() {
            addCriterion("pricereq is not null");
            return (Criteria) this;
        }

        public Criteria andPricereqEqualTo(Double value) {
            addCriterion("pricereq =", value, "pricereq");
            return (Criteria) this;
        }

        public Criteria andPricereqNotEqualTo(Double value) {
            addCriterion("pricereq <>", value, "pricereq");
            return (Criteria) this;
        }

        public Criteria andPricereqGreaterThan(Double value) {
            addCriterion("pricereq >", value, "pricereq");
            return (Criteria) this;
        }

        public Criteria andPricereqGreaterThanOrEqualTo(Double value) {
            addCriterion("pricereq >=", value, "pricereq");
            return (Criteria) this;
        }

        public Criteria andPricereqLessThan(Double value) {
            addCriterion("pricereq <", value, "pricereq");
            return (Criteria) this;
        }

        public Criteria andPricereqLessThanOrEqualTo(Double value) {
            addCriterion("pricereq <=", value, "pricereq");
            return (Criteria) this;
        }

        public Criteria andPricereqIn(List<Double> values) {
            addCriterion("pricereq in", values, "pricereq");
            return (Criteria) this;
        }

        public Criteria andPricereqNotIn(List<Double> values) {
            addCriterion("pricereq not in", values, "pricereq");
            return (Criteria) this;
        }

        public Criteria andPricereqBetween(Double value1, Double value2) {
            addCriterion("pricereq between", value1, value2, "pricereq");
            return (Criteria) this;
        }

        public Criteria andPricereqNotBetween(Double value1, Double value2) {
            addCriterion("pricereq not between", value1, value2, "pricereq");
            return (Criteria) this;
        }

        public Criteria andProspecIsNull() {
            addCriterion("prospec is null");
            return (Criteria) this;
        }

        public Criteria andProspecIsNotNull() {
            addCriterion("prospec is not null");
            return (Criteria) this;
        }

        public Criteria andProspecEqualTo(String value) {
            addCriterion("prospec =", value, "prospec");
            return (Criteria) this;
        }

        public Criteria andProspecNotEqualTo(String value) {
            addCriterion("prospec <>", value, "prospec");
            return (Criteria) this;
        }

        public Criteria andProspecGreaterThan(String value) {
            addCriterion("prospec >", value, "prospec");
            return (Criteria) this;
        }

        public Criteria andProspecGreaterThanOrEqualTo(String value) {
            addCriterion("prospec >=", value, "prospec");
            return (Criteria) this;
        }

        public Criteria andProspecLessThan(String value) {
            addCriterion("prospec <", value, "prospec");
            return (Criteria) this;
        }

        public Criteria andProspecLessThanOrEqualTo(String value) {
            addCriterion("prospec <=", value, "prospec");
            return (Criteria) this;
        }

        public Criteria andProspecLike(String value) {
            addCriterion("prospec like", value, "prospec");
            return (Criteria) this;
        }

        public Criteria andProspecNotLike(String value) {
            addCriterion("prospec not like", value, "prospec");
            return (Criteria) this;
        }

        public Criteria andProspecIn(List<String> values) {
            addCriterion("prospec in", values, "prospec");
            return (Criteria) this;
        }

        public Criteria andProspecNotIn(List<String> values) {
            addCriterion("prospec not in", values, "prospec");
            return (Criteria) this;
        }

        public Criteria andProspecBetween(String value1, String value2) {
            addCriterion("prospec between", value1, value2, "prospec");
            return (Criteria) this;
        }

        public Criteria andProspecNotBetween(String value1, String value2) {
            addCriterion("prospec not between", value1, value2, "prospec");
            return (Criteria) this;
        }

        public Criteria andPaytypeIsNull() {
            addCriterion("paytype is null");
            return (Criteria) this;
        }

        public Criteria andPaytypeIsNotNull() {
            addCriterion("paytype is not null");
            return (Criteria) this;
        }

        public Criteria andPaytypeEqualTo(String value) {
            addCriterion("paytype =", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotEqualTo(String value) {
            addCriterion("paytype <>", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeGreaterThan(String value) {
            addCriterion("paytype >", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeGreaterThanOrEqualTo(String value) {
            addCriterion("paytype >=", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeLessThan(String value) {
            addCriterion("paytype <", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeLessThanOrEqualTo(String value) {
            addCriterion("paytype <=", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeLike(String value) {
            addCriterion("paytype like", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotLike(String value) {
            addCriterion("paytype not like", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeIn(List<String> values) {
            addCriterion("paytype in", values, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotIn(List<String> values) {
            addCriterion("paytype not in", values, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeBetween(String value1, String value2) {
            addCriterion("paytype between", value1, value2, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotBetween(String value1, String value2) {
            addCriterion("paytype not between", value1, value2, "paytype");
            return (Criteria) this;
        }

        public Criteria andInvoctypeIsNull() {
            addCriterion("invoctype is null");
            return (Criteria) this;
        }

        public Criteria andInvoctypeIsNotNull() {
            addCriterion("invoctype is not null");
            return (Criteria) this;
        }

        public Criteria andInvoctypeEqualTo(String value) {
            addCriterion("invoctype =", value, "invoctype");
            return (Criteria) this;
        }

        public Criteria andInvoctypeNotEqualTo(String value) {
            addCriterion("invoctype <>", value, "invoctype");
            return (Criteria) this;
        }

        public Criteria andInvoctypeGreaterThan(String value) {
            addCriterion("invoctype >", value, "invoctype");
            return (Criteria) this;
        }

        public Criteria andInvoctypeGreaterThanOrEqualTo(String value) {
            addCriterion("invoctype >=", value, "invoctype");
            return (Criteria) this;
        }

        public Criteria andInvoctypeLessThan(String value) {
            addCriterion("invoctype <", value, "invoctype");
            return (Criteria) this;
        }

        public Criteria andInvoctypeLessThanOrEqualTo(String value) {
            addCriterion("invoctype <=", value, "invoctype");
            return (Criteria) this;
        }

        public Criteria andInvoctypeLike(String value) {
            addCriterion("invoctype like", value, "invoctype");
            return (Criteria) this;
        }

        public Criteria andInvoctypeNotLike(String value) {
            addCriterion("invoctype not like", value, "invoctype");
            return (Criteria) this;
        }

        public Criteria andInvoctypeIn(List<String> values) {
            addCriterion("invoctype in", values, "invoctype");
            return (Criteria) this;
        }

        public Criteria andInvoctypeNotIn(List<String> values) {
            addCriterion("invoctype not in", values, "invoctype");
            return (Criteria) this;
        }

        public Criteria andInvoctypeBetween(String value1, String value2) {
            addCriterion("invoctype between", value1, value2, "invoctype");
            return (Criteria) this;
        }

        public Criteria andInvoctypeNotBetween(String value1, String value2) {
            addCriterion("invoctype not between", value1, value2, "invoctype");
            return (Criteria) this;
        }

        public Criteria andShiaddressIsNull() {
            addCriterion("shiaddress is null");
            return (Criteria) this;
        }

        public Criteria andShiaddressIsNotNull() {
            addCriterion("shiaddress is not null");
            return (Criteria) this;
        }

        public Criteria andShiaddressEqualTo(String value) {
            addCriterion("shiaddress =", value, "shiaddress");
            return (Criteria) this;
        }

        public Criteria andShiaddressNotEqualTo(String value) {
            addCriterion("shiaddress <>", value, "shiaddress");
            return (Criteria) this;
        }

        public Criteria andShiaddressGreaterThan(String value) {
            addCriterion("shiaddress >", value, "shiaddress");
            return (Criteria) this;
        }

        public Criteria andShiaddressGreaterThanOrEqualTo(String value) {
            addCriterion("shiaddress >=", value, "shiaddress");
            return (Criteria) this;
        }

        public Criteria andShiaddressLessThan(String value) {
            addCriterion("shiaddress <", value, "shiaddress");
            return (Criteria) this;
        }

        public Criteria andShiaddressLessThanOrEqualTo(String value) {
            addCriterion("shiaddress <=", value, "shiaddress");
            return (Criteria) this;
        }

        public Criteria andShiaddressLike(String value) {
            addCriterion("shiaddress like", value, "shiaddress");
            return (Criteria) this;
        }

        public Criteria andShiaddressNotLike(String value) {
            addCriterion("shiaddress not like", value, "shiaddress");
            return (Criteria) this;
        }

        public Criteria andShiaddressIn(List<String> values) {
            addCriterion("shiaddress in", values, "shiaddress");
            return (Criteria) this;
        }

        public Criteria andShiaddressNotIn(List<String> values) {
            addCriterion("shiaddress not in", values, "shiaddress");
            return (Criteria) this;
        }

        public Criteria andShiaddressBetween(String value1, String value2) {
            addCriterion("shiaddress between", value1, value2, "shiaddress");
            return (Criteria) this;
        }

        public Criteria andShiaddressNotBetween(String value1, String value2) {
            addCriterion("shiaddress not between", value1, value2, "shiaddress");
            return (Criteria) this;
        }

        public Criteria andDeadlineIsNull() {
            addCriterion("deadline is null");
            return (Criteria) this;
        }

        public Criteria andDeadlineIsNotNull() {
            addCriterion("deadline is not null");
            return (Criteria) this;
        }

        public Criteria andDeadlineEqualTo(Date value) {
            addCriterion("deadline =", value, "deadline");
            return (Criteria) this;
        }

        public Criteria andDeadlineNotEqualTo(Date value) {
            addCriterion("deadline <>", value, "deadline");
            return (Criteria) this;
        }

        public Criteria andDeadlineGreaterThan(Date value) {
            addCriterion("deadline >", value, "deadline");
            return (Criteria) this;
        }

        public Criteria andDeadlineGreaterThanOrEqualTo(Date value) {
            addCriterion("deadline >=", value, "deadline");
            return (Criteria) this;
        }

        public Criteria andDeadlineLessThan(Date value) {
            addCriterion("deadline <", value, "deadline");
            return (Criteria) this;
        }

        public Criteria andDeadlineLessThanOrEqualTo(Date value) {
            addCriterion("deadline <=", value, "deadline");
            return (Criteria) this;
        }

        public Criteria andDeadlineIn(List<Date> values) {
            addCriterion("deadline in", values, "deadline");
            return (Criteria) this;
        }

        public Criteria andDeadlineNotIn(List<Date> values) {
            addCriterion("deadline not in", values, "deadline");
            return (Criteria) this;
        }

        public Criteria andDeadlineBetween(Date value1, Date value2) {
            addCriterion("deadline between", value1, value2, "deadline");
            return (Criteria) this;
        }

        public Criteria andDeadlineNotBetween(Date value1, Date value2) {
            addCriterion("deadline not between", value1, value2, "deadline");
            return (Criteria) this;
        }

        public Criteria andContactIsNull() {
            addCriterion("contact is null");
            return (Criteria) this;
        }

        public Criteria andContactIsNotNull() {
            addCriterion("contact is not null");
            return (Criteria) this;
        }

        public Criteria andContactEqualTo(String value) {
            addCriterion("contact =", value, "contact");
            return (Criteria) this;
        }

        public Criteria andContactNotEqualTo(String value) {
            addCriterion("contact <>", value, "contact");
            return (Criteria) this;
        }

        public Criteria andContactGreaterThan(String value) {
            addCriterion("contact >", value, "contact");
            return (Criteria) this;
        }

        public Criteria andContactGreaterThanOrEqualTo(String value) {
            addCriterion("contact >=", value, "contact");
            return (Criteria) this;
        }

        public Criteria andContactLessThan(String value) {
            addCriterion("contact <", value, "contact");
            return (Criteria) this;
        }

        public Criteria andContactLessThanOrEqualTo(String value) {
            addCriterion("contact <=", value, "contact");
            return (Criteria) this;
        }

        public Criteria andContactLike(String value) {
            addCriterion("contact like", value, "contact");
            return (Criteria) this;
        }

        public Criteria andContactNotLike(String value) {
            addCriterion("contact not like", value, "contact");
            return (Criteria) this;
        }

        public Criteria andContactIn(List<String> values) {
            addCriterion("contact in", values, "contact");
            return (Criteria) this;
        }

        public Criteria andContactNotIn(List<String> values) {
            addCriterion("contact not in", values, "contact");
            return (Criteria) this;
        }

        public Criteria andContactBetween(String value1, String value2) {
            addCriterion("contact between", value1, value2, "contact");
            return (Criteria) this;
        }

        public Criteria andContactNotBetween(String value1, String value2) {
            addCriterion("contact not between", value1, value2, "contact");
            return (Criteria) this;
        }

        public Criteria andComnameIsNull() {
            addCriterion("comname is null");
            return (Criteria) this;
        }

        public Criteria andComnameIsNotNull() {
            addCriterion("comname is not null");
            return (Criteria) this;
        }

        public Criteria andComnameEqualTo(String value) {
            addCriterion("comname =", value, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameNotEqualTo(String value) {
            addCriterion("comname <>", value, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameGreaterThan(String value) {
            addCriterion("comname >", value, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameGreaterThanOrEqualTo(String value) {
            addCriterion("comname >=", value, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameLessThan(String value) {
            addCriterion("comname <", value, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameLessThanOrEqualTo(String value) {
            addCriterion("comname <=", value, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameLike(String value) {
            addCriterion("comname like", value, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameNotLike(String value) {
            addCriterion("comname not like", value, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameIn(List<String> values) {
            addCriterion("comname in", values, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameNotIn(List<String> values) {
            addCriterion("comname not in", values, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameBetween(String value1, String value2) {
            addCriterion("comname between", value1, value2, "comname");
            return (Criteria) this;
        }

        public Criteria andComnameNotBetween(String value1, String value2) {
            addCriterion("comname not between", value1, value2, "comname");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNull() {
            addCriterion("phone is null");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNotNull() {
            addCriterion("phone is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneEqualTo(String value) {
            addCriterion("phone =", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotEqualTo(String value) {
            addCriterion("phone <>", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThan(String value) {
            addCriterion("phone >", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("phone >=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThan(String value) {
            addCriterion("phone <", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThanOrEqualTo(String value) {
            addCriterion("phone <=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLike(String value) {
            addCriterion("phone like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotLike(String value) {
            addCriterion("phone not like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneIn(List<String> values) {
            addCriterion("phone in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotIn(List<String> values) {
            addCriterion("phone not in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneBetween(String value1, String value2) {
            addCriterion("phone between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotBetween(String value1, String value2) {
            addCriterion("phone not between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andProtateIsNull() {
            addCriterion("protate is null");
            return (Criteria) this;
        }

        public Criteria andProtateIsNotNull() {
            addCriterion("protate is not null");
            return (Criteria) this;
        }

        public Criteria andProtateEqualTo(Integer value) {
            addCriterion("protate =", value, "protate");
            return (Criteria) this;
        }

        public Criteria andProtateNotEqualTo(Integer value) {
            addCriterion("protate <>", value, "protate");
            return (Criteria) this;
        }

        public Criteria andProtateGreaterThan(Integer value) {
            addCriterion("protate >", value, "protate");
            return (Criteria) this;
        }

        public Criteria andProtateGreaterThanOrEqualTo(Integer value) {
            addCriterion("protate >=", value, "protate");
            return (Criteria) this;
        }

        public Criteria andProtateLessThan(Integer value) {
            addCriterion("protate <", value, "protate");
            return (Criteria) this;
        }

        public Criteria andProtateLessThanOrEqualTo(Integer value) {
            addCriterion("protate <=", value, "protate");
            return (Criteria) this;
        }

        public Criteria andProtateIn(List<Integer> values) {
            addCriterion("protate in", values, "protate");
            return (Criteria) this;
        }

        public Criteria andProtateNotIn(List<Integer> values) {
            addCriterion("protate not in", values, "protate");
            return (Criteria) this;
        }

        public Criteria andProtateBetween(Integer value1, Integer value2) {
            addCriterion("protate between", value1, value2, "protate");
            return (Criteria) this;
        }

        public Criteria andProtateNotBetween(Integer value1, Integer value2) {
            addCriterion("protate not between", value1, value2, "protate");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}